-- ================================================
-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters 
-- command (Ctrl-Shift-M) to fill in the parameter 
-- values below.
--
-- This block of comments will not be included in
-- the definition of the procedure.
-- ================================================
USE [WarehouseManagement]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		duylv00360
-- Create date: 3/19/2011
-- Description:	This stored procedure use to insert a new order into database
-- =============================================
ALTER PROCEDURE InsertOrder 
	-- Add the parameters for the stored procedure here
	@OrderCode char(16),
	@OrderDate datetime, 
	@EmployeeAID int = 0,
	@ContactID int = null,
	@EmployeeBID int = null,
	@IsImport bit = 1,
	@OrderID int = -1 OUTPUT
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;	
    -- Insert statements for procedure here
    --DECLARE @PreOrderID int 
    --SET @PreOrderID = IDENT_CURRENT('OrderID')
	INSERT INTO [Order](
				OrderCode,
				Date,
				EmployeeAID,
				ContactID,
				EmployeeBID,
				IsImport)
	VALUES		(@OrderCode, 
				@OrderDate, 
				@EmployeeAID, 
				@ContactID, 
				@EmployeeBID, 
				@IsImport)
	--SET @OrderID = IDENT_CURRENT('OrderID')
	--IF (@OrderID <= @PreOrderID)
	--	 SET @OrderID = -1
	 
	--SELECT @OrderID	 
	--SELECT IDENT_CURRENT('OrderID') AS 'OrderID'
	select @OrderID = scope_identity ()
	 
END
GO

/*
use WarehouseManagement
go
exec InsertOrder	@orderCode = 'MI1124072000' ,
					@orderDate = '20010406',
					@EmployeeAID = 2 , 
					--@ContactID = 2, 
					--@EmployeeBID = 2, 
					@IsImport =1
*/